<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-weight:400; font-style:normal; "  bgcolor="#ffffff">
Version:0.9
StartHTML:0000000207
EndHTML:0000243539
StartFragment:0000000243
EndFragment:0000243503
SourceURL:https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/
<html>
<body>
<!--StartFragment--><div class="entry-header" style="box-sizing: border-box; text-align: var(--textalign,center); --textalign: left; margin-top: 60px; margin-bottom: var(--spacing,60px); color: rgb(39, 38, 38); font-family: Arial, Helvetica, sans-serif, Arial, Helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><div class="nv-title-meta-wrap" style="box-sizing: border-box;"><h1 class="title entry-title" style="box-sizing: border-box; margin: 0px 0px 10px; padding: 0px; font-size: var(--fontsize,var(--h1fontsize)); font-weight: var(--fontweight,var(--h1fontweight)); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--lineheight,var(--h1lineheight)); letter-spacing: var(--letterspacing,var(--h1letterspacing)); text-transform: var(--texttransform,var(--h1texttransform)); overflow-wrap: break-word;">VBA Excel. Выделенный диапазон ячеек (адрес, выбор, строки)</h1><ul class="nv-meta-list" style="box-sizing: border-box; margin: 0px 0px 20px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: var(--liststyle,none); font-size: 0.9em; --avatarsize: 20px;"></ul></div></div><div class="nv-content-wrap entry-content" style="box-sizing: border-box; counter-reset: footnotes 0; --listpad: 20px; --liststyle: disc; --img-m: 24px; margin-bottom: var(--spacing,60px); color: rgb(39, 38, 38); font-family: Arial, Helvetica, sans-serif, Arial, Helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; height: auto !important;"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><em style="box-sizing: border-box;">Определение адреса выделенного диапазона ячеек на листе Excel с помощью кода VBA. Определение номера первой и последней строки. Программное выделение диапазона.</em><span id="more-1313" style="box-sizing: border-box;"></span></p><div class="lwptoc lwptoc-autoWidth lwptoc-baseItems lwptoc-light lwptoc-notInherit" data-smooth-scroll="1" data-smooth-scroll-offset="24" data-lwptoc-initialized="1" style="box-sizing: border-box; margin: 32px 0px;"><div class="lwptoc_i" style="box-sizing: border-box; padding: 14px 18px 18px; text-align: left; display: inline-block; color: rgb(51, 51, 51); background: rgb(250, 250, 250);"><div class="lwptoc_header" style="box-sizing: border-box; margin-bottom: 6px;"><b class="lwptoc_title" style="box-sizing: border-box; font-weight: 600;">Содержание</b></div><div class="lwptoc_items lwptoc_items-visible" style="box-sizing: border-box; font-size: 14.4px;"><div class="lwptoc_itemWrap" style="box-sizing: border-box;"><div class="lwptoc_item" style="box-sizing: border-box; margin-top: 0px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#Adres_vydelennogo_diapazona" style="box-sizing: border-box; --linkdeco: underline; color: rgb(49, 117, 228); cursor: pointer; text-decoration: none !important; box-shadow: none !important; border: none !important;"><span class="lwptoc_item_number" style="box-sizing: border-box; margin-right: 2px;">1.</span><span> </span><span class="lwptoc_item_label" style="box-sizing: border-box;">Адрес выделенного диапазона</span></a></div><div class="lwptoc_item" style="box-sizing: border-box; margin-top: 2px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#Vydelenie_aceek_i_diapazonov" style="box-sizing: border-box; --linkdeco: underline; color: rgb(49, 117, 228); cursor: pointer; text-decoration: none !important; box-shadow: none !important; border: none !important;"><span class="lwptoc_item_number" style="box-sizing: border-box; margin-right: 2px;">2.</span><span> </span><span class="lwptoc_item_label" style="box-sizing: border-box;">Выделение ячеек и диапазонов</span></a></div><div class="lwptoc_item" style="box-sizing: border-box; margin-top: 2px;"><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#Opredelenie_nomerov_pervoj_i_poslednej_stroki" style="box-sizing: border-box; --linkdeco: underline; color: rgb(49, 117, 228); cursor: pointer; text-decoration: none !important; box-shadow: none !important; border: none !important;"><span class="lwptoc_item_number" style="box-sizing: border-box; margin-right: 2px;">3.</span><span> </span><span class="lwptoc_item_label" style="box-sizing: border-box;">Определение номеров первой и последней строки</span></a></div></div></div></div></div><h2 style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; font-size: var(--h2fontsize); font-weight: var(--h2fontweight); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--h2lineheight); letter-spacing: var(--h2letterspacing); text-transform: var(--h2texttransform);"><span id="Adres_vydelennogo_diapazona" style="box-sizing: border-box;">Адрес выделенного диапазона</span></h2><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Для определения адреса выделенного диапазона ячеек в VBA Excel используется свойство <strong style="box-sizing: border-box;">Address</strong><span> </span>объекта <strong style="box-sizing: border-box;">Selection</strong>.</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Объект<span> </span><strong style="box-sizing: border-box;">Selection</strong><span> </span>— это совокупность всех выделенных ячеек на листе Excel. Это может быть одна ячейка, смежный или несмежный диапазон ячеек, представляющий<span> </span><a href="https://vremya-ne-zhdet.ru/vba-excel/svoystvo-areas-obyekta-range/" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);">коллекцию смежных диапазонов</a>. Если выделение состоит из несмежного диапазона, адреса смежных диапазонов, из которых он состоит, будут перечислены через запятую.</p><div class="google-auto-placed ap_container" style="box-sizing: border-box; width: 960px; height: auto; clear: both; text-align: center;"><ins data-ad-format="auto" class="adsbygoogle adsbygoogle-noablate" data-ad-client="ca-pub-3460721053602142" data-adsbygoogle-status="done" data-ad-status="unfilled" style="box-sizing: border-box; text-decoration: none; display: block; margin: auto; background-color: transparent; height: 0px;"><div id="aswift_1_host" tabindex="0" title="Advertisement" aria-label="Advertisement" style="box-sizing: border-box; border: none; height: 0px; width: 960px; margin: 0px; padding: 0px; position: relative; visibility: visible; background-color: transparent; display: inline-block; overflow: hidden; opacity: 0;"><iframe id="aswift_1" name="aswift_1" browsingtopics="true" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" width="960" height="0" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allow="attribution-reporting" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3460721053602142&amp;output=html&amp;h=280&amp;adk=81149847&amp;adf=2040984433&amp;pi=t.aa~a.2994879612~i.8~rp.4&amp;w=960&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1694973846&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=9507011714&amp;ad_type=text_image&amp;format=960x280&amp;url=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fvba-excel%2Fvydelennyy-diapazon-yacheyek-selection-address-range%2F&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=960&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;uach=WyJXaW5kb3dzIiwiMTAuMC4wIiwieDg2IiwiIiwiMTE2LjAuNTg0NS4xODgiLFtdLDAsbnVsbCwiNjQiLFtbIkNocm9taXVtIiwiMTE2LjAuNTg0NS4xODgiXSxbIk5vdClBO0JyYW5kIiwiMjQuMC4wLjAiXSxbIkdvb2dsZSBDaHJvbWUiLCIxMTYuMC41ODQ1LjE4OCJdXSwxXQ..&amp;dt=1694973698301&amp;bpp=1&amp;bdt=357&amp;idt=1&amp;shv=r20230913&amp;mjsv=m202309120101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D294d8f47e3279632-2206045a72de0082%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MZo2E68X78wZPYUgfo__j3aXUXvzQ&amp;gpic=UID%3D00000d9335f20261%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MbxtqTlOisQs9McCFUD5w6cq5xBtg&amp;prev_fmts=0x0&amp;nras=2&amp;correlator=5227852080414&amp;frm=20&amp;pv=1&amp;ga_vid=385661260.1694442668&amp;ga_sid=1694973698&amp;ga_hid=1661767875&amp;ga_fc=1&amp;u_tz=180&amp;u_his=1&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1080&amp;u_aw=1803&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=413&amp;ady=987&amp;biw=1786&amp;bih=971&amp;scr_x=0&amp;scr_y=0&amp;eid=44759842%2C44759875%2C44759926%2C31076839%2C31077698%2C31077774%2C44795921%2C44801484%2C31076996%2C44800658%2C31067146%2C31067147%2C31067148%2C31068556%2C44800311&amp;oid=2&amp;pvsid=3420165173659154&amp;tmod=711968303&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fcategory%2Fvba-excel%2Fpage%2F11%2F&amp;fc=1408&amp;brdim=0%2C0%2C0%2C0%2C1803%2C0%2C0%2C0%2C1803%2C971&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;fu=128&amp;bc=31&amp;td=1&amp;nt=1&amp;ifi=2&amp;uci=a!2&amp;btvi=1&amp;fsb=1&amp;xpc=VdghuEiiIG&amp;p=https%3A//vremya-ne-zhdet.ru&amp;dtd=M" data-google-container-id="a!2" data-google-query-id="CLH95dGdsoEDFY_SOwIdZl4EhQ" data-load-complete="true" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; max-width: 100%; left: 0px; position: absolute; top: 0px; width: 960px; height: 0px;"></iframe></div></ins></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><strong style="box-sizing: border-box;">Смежный диапазон</strong><span> </span>— прямоугольная область смежных (прилегающих друг к другу) ячеек.</p><div class="google-auto-placed ap_container" style="box-sizing: border-box; width: 960px; height: auto; clear: both; text-align: center;"><ins data-ad-format="auto" class="adsbygoogle adsbygoogle-noablate" data-ad-client="ca-pub-3460721053602142" data-adsbygoogle-status="done" data-ad-status="unfilled" style="box-sizing: border-box; text-decoration: none; display: block; margin: auto; background-color: transparent; height: 0px;"><div id="aswift_2_host" tabindex="0" title="Advertisement" aria-label="Advertisement" style="box-sizing: border-box; border: none; height: 0px; width: 960px; margin: 0px; padding: 0px; position: relative; visibility: visible; background-color: transparent; display: inline-block; overflow: hidden; opacity: 0;"><iframe id="aswift_2" name="aswift_2" browsingtopics="true" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" width="960" height="0" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allow="attribution-reporting" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3460721053602142&amp;output=html&amp;h=280&amp;adk=81149847&amp;adf=2220264510&amp;pi=t.aa~a.2994879612~i.10~rp.4&amp;w=960&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1694973846&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=9507011714&amp;ad_type=text_image&amp;format=960x280&amp;url=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fvba-excel%2Fvydelennyy-diapazon-yacheyek-selection-address-range%2F&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=960&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;uach=WyJXaW5kb3dzIiwiMTAuMC4wIiwieDg2IiwiIiwiMTE2LjAuNTg0NS4xODgiLFtdLDAsbnVsbCwiNjQiLFtbIkNocm9taXVtIiwiMTE2LjAuNTg0NS4xODgiXSxbIk5vdClBO0JyYW5kIiwiMjQuMC4wLjAiXSxbIkdvb2dsZSBDaHJvbWUiLCIxMTYuMC41ODQ1LjE4OCJdXSwxXQ..&amp;dt=1694973698305&amp;bpp=1&amp;bdt=361&amp;idt=1&amp;shv=r20230913&amp;mjsv=m202309120101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D294d8f47e3279632-2206045a72de0082%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MZo2E68X78wZPYUgfo__j3aXUXvzQ&amp;gpic=UID%3D00000d9335f20261%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MbxtqTlOisQs9McCFUD5w6cq5xBtg&amp;prev_fmts=0x0%2C960x280&amp;nras=3&amp;correlator=5227852080414&amp;frm=20&amp;pv=1&amp;ga_vid=385661260.1694442668&amp;ga_sid=1694973698&amp;ga_hid=1661767875&amp;ga_fc=1&amp;u_tz=180&amp;u_his=1&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1080&amp;u_aw=1803&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=413&amp;ady=1324&amp;biw=1786&amp;bih=971&amp;scr_x=0&amp;scr_y=0&amp;eid=44759842%2C44759875%2C44759926%2C31076839%2C31077698%2C31077774%2C44795921%2C44801484%2C31076996%2C44800658%2C31067146%2C31067147%2C31067148%2C31068556%2C44800311&amp;oid=2&amp;pvsid=3420165173659154&amp;tmod=711968303&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fcategory%2Fvba-excel%2Fpage%2F11%2F&amp;fc=1408&amp;brdim=0%2C0%2C0%2C0%2C1803%2C0%2C0%2C0%2C1803%2C971&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;fu=128&amp;bc=31&amp;td=1&amp;nt=1&amp;ifi=3&amp;uci=a!3&amp;btvi=2&amp;fsb=1&amp;xpc=yqMGrlmQcZ&amp;p=https%3A//vremya-ne-zhdet.ru&amp;dtd=M" data-google-container-id="a!3" data-google-query-id="CIeF6NGdsoEDFcGkmgodo5UAXQ" data-load-complete="true" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; max-width: 100%; left: 0px; position: absolute; top: 0px; width: 960px; height: 0px;"></iframe></div></ins></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"><strong style="box-sizing: border-box;">Несмежный диапазон</strong><span> </span>— совокупность (коллекция) смежных диапазонов (прямоугольных областей смежных ячеек).</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Стоит отметить: несмотря на то, что в выделенном диапазоне может содержаться много ячеек, активной может быть только одна. Она представлена объектом<span> </span><strong style="box-sizing: border-box;">ActiveCell</strong>. Для определения ее адреса в коде VBA Excel также используется свойство <strong style="box-sizing: border-box;">Address</strong>.</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><div id="urvanov-syntax-highlighter-65073f04c483a932067150" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 960px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 958px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c483a932067150-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c483a932067150-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c483a932067150-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c483a932067150-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c483a932067150-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c483a932067150-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 940.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c483a932067150-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c483a932067150-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">MsgBox</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Адрес выделенного диапазона: "</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Selection</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Address</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">_</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c483a932067150-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">vbNewLine</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Адрес активной ячейки: "</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">ActiveCell</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Address</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">_</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c483a932067150-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">vbNewLine</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Номер строки активной ячейки: "</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">ActiveCell</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Row</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">_</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c483a932067150-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">vbNewLine</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Номер столбца активной ячейки: "</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">ActiveCell</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Column</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c483a932067150-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Скопируйте и запустите код на выполнение. В результате получите что-то вроде этого, зависящее от того, какие диапазоны вы выберите:</p><div class="google-auto-placed ap_container" style="box-sizing: border-box; width: 960px; height: auto; clear: both; text-align: center;"><ins data-ad-format="auto" class="adsbygoogle adsbygoogle-noablate" data-ad-client="ca-pub-3460721053602142" data-adsbygoogle-status="done" data-ad-status="unfilled" style="box-sizing: border-box; text-decoration: none; display: block; margin: auto; background-color: transparent; height: 0px;"><div id="aswift_3_host" tabindex="0" title="Advertisement" aria-label="Advertisement" style="box-sizing: border-box; border: none; height: 0px; width: 960px; margin: 0px; padding: 0px; position: relative; visibility: visible; background-color: transparent; display: inline-block; overflow: hidden; opacity: 0;"><iframe id="aswift_3" name="aswift_3" browsingtopics="true" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" width="960" height="0" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allow="attribution-reporting" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3460721053602142&amp;output=html&amp;h=280&amp;adk=81149847&amp;adf=994973890&amp;pi=t.aa~a.2994879612~i.29~rp.4&amp;w=960&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1694973846&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=9507011714&amp;ad_type=text_image&amp;format=960x280&amp;url=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fvba-excel%2Fvydelennyy-diapazon-yacheyek-selection-address-range%2F&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=960&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;uach=WyJXaW5kb3dzIiwiMTAuMC4wIiwieDg2IiwiIiwiMTE2LjAuNTg0NS4xODgiLFtdLDAsbnVsbCwiNjQiLFtbIkNocm9taXVtIiwiMTE2LjAuNTg0NS4xODgiXSxbIk5vdClBO0JyYW5kIiwiMjQuMC4wLjAiXSxbIkdvb2dsZSBDaHJvbWUiLCIxMTYuMC41ODQ1LjE4OCJdXSwxXQ..&amp;dt=1694973698308&amp;bpp=1&amp;bdt=364&amp;idt=0&amp;shv=r20230913&amp;mjsv=m202309120101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D294d8f47e3279632-2206045a72de0082%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MZo2E68X78wZPYUgfo__j3aXUXvzQ&amp;gpic=UID%3D00000d9335f20261%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MbxtqTlOisQs9McCFUD5w6cq5xBtg&amp;prev_fmts=0x0%2C960x280%2C960x280&amp;nras=4&amp;correlator=5227852080414&amp;frm=20&amp;pv=1&amp;ga_vid=385661260.1694442668&amp;ga_sid=1694973698&amp;ga_hid=1661767875&amp;ga_fc=1&amp;u_tz=180&amp;u_his=1&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1080&amp;u_aw=1803&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=413&amp;ady=1979&amp;biw=1786&amp;bih=971&amp;scr_x=0&amp;scr_y=0&amp;eid=44759842%2C44759875%2C44759926%2C31076839%2C31077698%2C31077774%2C44795921%2C44801484%2C31076996%2C44800658%2C31067146%2C31067147%2C31067148%2C31068556%2C44800311&amp;oid=2&amp;pvsid=3420165173659154&amp;tmod=711968303&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fcategory%2Fvba-excel%2Fpage%2F11%2F&amp;fc=1408&amp;brdim=0%2C0%2C0%2C0%2C1803%2C0%2C0%2C0%2C1803%2C971&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;fu=128&amp;bc=31&amp;td=1&amp;nt=1&amp;ifi=4&amp;uci=a!4&amp;btvi=3&amp;fsb=1&amp;xpc=9D01nAboIt&amp;p=https%3A//vremya-ne-zhdet.ru&amp;dtd=M" data-google-container-id="a!4" data-google-query-id="COnZ59GdsoEDFafXOwIdHJoKKw" data-load-complete="true" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; max-width: 100%; left: 0px; position: absolute; top: 0px; width: 960px; height: 0px;"></iframe></div></ins></div><div id="attachment_2057" class="wp-caption aligncenter" style="box-sizing: border-box; clear: both; display: block; text-align: center; margin: 0px auto; max-width: 100%; width: 485px;"><a href="https://vremya-ne-zhdet.ru/wp-content/uploads/2018/03/adres-diapazona.png" target="_blank" rel="noopener" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);"></a><p id="caption-attachment-2057" class="wp-caption-text" style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; text-align: center; font-size: 0.8em; font-weight: 500;">Определение адресов выделенного диапазона и активной ячейки</p></div><h2 style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; font-size: var(--h2fontsize); font-weight: var(--h2fontweight); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--h2lineheight); letter-spacing: var(--h2letterspacing); text-transform: var(--h2texttransform);"><span id="Vydelenie_aceek_i_diapazonov" style="box-sizing: border-box;">Выделение ячеек и диапазонов</span></h2><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Выделить несмежный диапазон ячеек можно следующим образом:</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><div id="urvanov-syntax-highlighter-65073f04c4851665551787" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 960px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 958px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c4851665551787-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c4851665551787-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c4851665551787-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 940.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c4851665551787-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c4851665551787-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Range</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"B4:C7,E5:F7,D8"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Select</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c4851665551787-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><div class="google-auto-placed ap_container" style="box-sizing: border-box; width: 960px; height: auto; clear: both; text-align: center;"><ins data-ad-format="auto" class="adsbygoogle adsbygoogle-noablate" data-ad-client="ca-pub-3460721053602142" data-adsbygoogle-status="done" data-ad-status="unfilled" style="box-sizing: border-box; text-decoration: none; display: block; margin: auto; background-color: transparent; height: 0px;"><div id="aswift_4_host" tabindex="0" title="Advertisement" aria-label="Advertisement" style="box-sizing: border-box; border: none; height: 0px; width: 960px; margin: 0px; padding: 0px; position: relative; visibility: visible; background-color: transparent; display: inline-block; overflow: hidden; opacity: 0;"><iframe id="aswift_4" name="aswift_4" browsingtopics="true" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" width="960" height="0" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allow="attribution-reporting" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3460721053602142&amp;output=html&amp;h=280&amp;adk=81149847&amp;adf=1565135796&amp;pi=t.aa~a.2994879612~i.44~rp.4&amp;w=960&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1694973846&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=9507011714&amp;ad_type=text_image&amp;format=960x280&amp;url=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fvba-excel%2Fvydelennyy-diapazon-yacheyek-selection-address-range%2F&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=960&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;uach=WyJXaW5kb3dzIiwiMTAuMC4wIiwieDg2IiwiIiwiMTE2LjAuNTg0NS4xODgiLFtdLDAsbnVsbCwiNjQiLFtbIkNocm9taXVtIiwiMTE2LjAuNTg0NS4xODgiXSxbIk5vdClBO0JyYW5kIiwiMjQuMC4wLjAiXSxbIkdvb2dsZSBDaHJvbWUiLCIxMTYuMC41ODQ1LjE4OCJdXSwxXQ..&amp;dt=1694973698311&amp;bpp=1&amp;bdt=367&amp;idt=0&amp;shv=r20230913&amp;mjsv=m202309120101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D294d8f47e3279632-2206045a72de0082%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MZo2E68X78wZPYUgfo__j3aXUXvzQ&amp;gpic=UID%3D00000d9335f20261%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MbxtqTlOisQs9McCFUD5w6cq5xBtg&amp;prev_fmts=0x0%2C960x280%2C960x280%2C960x280&amp;nras=5&amp;correlator=5227852080414&amp;frm=20&amp;pv=1&amp;ga_vid=385661260.1694442668&amp;ga_sid=1694973698&amp;ga_hid=1661767875&amp;ga_fc=1&amp;u_tz=180&amp;u_his=1&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1080&amp;u_aw=1803&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=413&amp;ady=2964&amp;biw=1786&amp;bih=971&amp;scr_x=0&amp;scr_y=0&amp;eid=44759842%2C44759875%2C44759926%2C31076839%2C31077698%2C31077774%2C44795921%2C44801484%2C31076996%2C44800658%2C31067146%2C31067147%2C31067148%2C31068556%2C44800311&amp;oid=2&amp;pvsid=3420165173659154&amp;tmod=711968303&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fcategory%2Fvba-excel%2Fpage%2F11%2F&amp;fc=1408&amp;brdim=0%2C0%2C0%2C0%2C1803%2C0%2C0%2C0%2C1803%2C971&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;cms=2&amp;fu=128&amp;bc=31&amp;td=1&amp;nt=1&amp;ifi=5&amp;uci=a!5&amp;btvi=4&amp;fsb=1&amp;xpc=7WCngoNRTl&amp;p=https%3A//vremya-ne-zhdet.ru&amp;dtd=M" data-google-container-id="a!5" data-google-query-id="CO2B6NGdsoEDFRCfmwodtZgKWQ" data-load-complete="true" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; max-width: 100%; left: 0px; position: absolute; top: 0px; width: 960px; height: 0px;"></iframe></div></ins></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Как видно из примера, в адресной строке объекта<span> </span><strong style="box-sizing: border-box;">Range</strong><span> </span>перечисляются адреса смежных диапазонов, составляющих общий несмежный диапазон, через запятую. Выделение осуществляется методом <strong style="box-sizing: border-box;">Select</strong> объекта<span> </span><strong style="box-sizing: border-box;">Range.</strong></p><h2 style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; font-size: var(--h2fontsize); font-weight: var(--h2fontweight); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--h2lineheight); letter-spacing: var(--h2letterspacing); text-transform: var(--h2texttransform);"><span id="Opredelenie_nomerov_pervoj_i_poslednej_stroki" style="box-sizing: border-box;">Определение номеров первой и последней строки</span></h2><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Чтобы вычислить номера первой и последней строки выделенного диапазона, будем исходить из того, что первая ячейка смежного диапазона находится на первой строке, а последняя — на последней строке выделенного диапазона.</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><div id="urvanov-syntax-highlighter-65073f04c485c791407500" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 960px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 958px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c485c791407500-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">7</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 940.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer3</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">i1 </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Long</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">i2 </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Long</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i1</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Selection</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Cells</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Row</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i2</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Selection</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Cells</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Selection</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Cells</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Count</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Row</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">MsgBox</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Первая строка: "</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i1</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">_</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">vbNewLine</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Последняя строка: "</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">i2</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c485c791407500-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;"></p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Результат будет таким, зависит от выделенного диапазона:</p><div id="attachment_1316" class="wp-caption aligncenter" style="box-sizing: border-box; clear: both; display: block; text-align: center; margin: 0px auto; max-width: 100%; width: 610px;"><a href="https://vremya-ne-zhdet.ru/wp-content/uploads/2017/02/nomera-strok-diapazona.png" target="_blank" rel="noopener" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);"></a><p id="caption-attachment-1316" class="wp-caption-text" style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px; text-align: center; font-size: 0.8em; font-weight: 500;">Номера первой и последней строки выделенного смежного диапазона</p></div><div class="google-auto-placed ap_container" style="box-sizing: border-box; width: 960px; height: auto; clear: both; text-align: center;"><ins data-ad-format="auto" class="adsbygoogle adsbygoogle-noablate" data-ad-client="ca-pub-3460721053602142" data-adsbygoogle-status="done" data-ad-status="unfilled" style="box-sizing: border-box; text-decoration: none; display: block; margin: auto; background-color: transparent; height: 0px;"><div id="aswift_5_host" tabindex="0" title="Advertisement" aria-label="Advertisement" style="box-sizing: border-box; border: none; height: 0px; width: 960px; margin: 0px; padding: 0px; position: relative; visibility: visible; background-color: transparent; display: inline-block; overflow: hidden; opacity: 0;"><iframe id="aswift_5" name="aswift_5" browsingtopics="true" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" width="960" height="0" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allow="attribution-reporting" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3460721053602142&amp;output=html&amp;h=280&amp;adk=81149847&amp;adf=3234687306&amp;pi=t.aa~a.2994879612~i.71~rp.4&amp;w=960&amp;fwrn=4&amp;fwrnh=100&amp;lmt=1694973846&amp;num_ads=1&amp;rafmt=1&amp;armr=3&amp;sem=mc&amp;pwprc=9507011714&amp;ad_type=text_image&amp;format=960x280&amp;url=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fvba-excel%2Fvydelennyy-diapazon-yacheyek-selection-address-range%2F&amp;fwr=0&amp;pra=3&amp;rh=200&amp;rw=960&amp;rpe=1&amp;resp_fmts=3&amp;wgl=1&amp;fa=27&amp;uach=WyJXaW5kb3dzIiwiMTAuMC4wIiwieDg2IiwiIiwiMTE2LjAuNTg0NS4xODgiLFtdLDAsbnVsbCwiNjQiLFtbIkNocm9taXVtIiwiMTE2LjAuNTg0NS4xODgiXSxbIk5vdClBO0JyYW5kIiwiMjQuMC4wLjAiXSxbIkdvb2dsZSBDaHJvbWUiLCIxMTYuMC41ODQ1LjE4OCJdXSwxXQ..&amp;dt=1694973698313&amp;bpp=1&amp;bdt=370&amp;idt=1&amp;shv=r20230913&amp;mjsv=m202309120101&amp;ptt=9&amp;saldr=aa&amp;abxe=1&amp;cookie=ID%3D294d8f47e3279632-2206045a72de0082%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MZo2E68X78wZPYUgfo__j3aXUXvzQ&amp;gpic=UID%3D00000d9335f20261%3AT%3D1694800950%3ART%3D1694973469%3AS%3DALNI_MbxtqTlOisQs9McCFUD5w6cq5xBtg&amp;prev_fmts=0x0%2C960x280%2C960x280%2C960x280%2C960x280&amp;nras=6&amp;correlator=5227852080414&amp;frm=20&amp;pv=1&amp;ga_vid=385661260.1694442668&amp;ga_sid=1694973698&amp;ga_hid=1661767875&amp;ga_fc=1&amp;u_tz=180&amp;u_his=1&amp;u_h=1080&amp;u_w=1920&amp;u_ah=1080&amp;u_aw=1803&amp;u_cd=24&amp;u_sd=1&amp;dmc=8&amp;adx=413&amp;ady=3786&amp;biw=1786&amp;bih=971&amp;scr_x=0&amp;scr_y=0&amp;eid=44759842%2C44759875%2C44759926%2C31076839%2C31077698%2C31077774%2C44795921%2C44801484%2C31076996%2C44800658%2C31067146%2C31067147%2C31067148%2C31068556%2C44800311&amp;oid=2&amp;pvsid=3420165173659154&amp;tmod=711968303&amp;uas=0&amp;nvt=1&amp;ref=https%3A%2F%2Fvremya-ne-zhdet.ru%2Fcategory%2Fvba-excel%2Fpage%2F11%2F&amp;fc=1408&amp;brdim=117%2C0%2C117%2C0%2C1803%2C0%2C1803%2C1080%2C1803%2C971&amp;vis=1&amp;rsz=%7C%7Cs%7C&amp;abl=NS&amp;fu=128&amp;bc=31&amp;td=1&amp;nt=1&amp;ifi=6&amp;uci=a!6&amp;btvi=5&amp;fsb=1&amp;xpc=W56Ibno1jL&amp;p=https%3A//vremya-ne-zhdet.ru&amp;dtd=M" data-google-container-id="a!6" data-google-query-id="COik7dGdsoEDFcrbOwIdyrQIhg" data-load-complete="true" style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; max-width: 100%; left: 0px; position: absolute; top: 0px; width: 960px; height: 0px;"></iframe></div></ins></div><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Таким же образом можно вычислить номера первого и последнего столбцов выделенного диапазона, которые можно использовать для обработки информации по столбцам.</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Обратите внимание, что для несмежных диапазонов этот пример не работает.</p><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">На практике я использовал определение номеров первой и последней строк по выделенному диапазону для формирования файла загрузки данных держателей дисконтных карт на сервис отправки СМС-сообщений. Оказалось, что базу данных клиентов заполнять в таблице Excel намного удобнее, чем на портале сервиса, а для загрузки в сервис достаточно сформировать несложный файл. Заполнил новые строки, выделил их по любому столбцу, нажал кнопку и файл готов.</p><hr style="box-sizing: border-box; margin: 10px 0px 20px; padding: 0px; color: inherit; height: 0px; border-width: 2px 0px 0px; border-right-style: initial; border-bottom-style: initial; border-left-style: initial; border-color: initial; border-image: initial; border-top-style: solid; display: inline-block; width: 960px;"><div class="blok-fon-3" style="box-sizing: border-box; width: auto; height: auto; padding: 0.4375rem; margin: 0px 0px 1.5rem; background-color: rgb(230, 230, 250);"><a href="https://vremya-ne-zhdet.ru/vba-excel/soderzhaniye-rubriki/" style="box-sizing: border-box; --linkdeco: underline; color: var(--nv-primary-accent); cursor: pointer; text-decoration: var(--linkdeco);">Содержание рубрики VBA Excel</a><span> </span>по тематическим разделам со ссылками на все статьи.</div></div><div id="comments" class="comments-area" style="box-sizing: border-box; padding-bottom: 30px; color: rgb(39, 38, 38); font-family: Arial, Helvetica, sans-serif, Arial, Helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><div class="nv-comments-wrap" style="box-sizing: border-box;"><div class="nv-comments-title-wrap" style="box-sizing: border-box;"><h2 class="comments-title" style="box-sizing: border-box; margin: 0px 0px 80px; padding: 0px; font-size: var(--fontsize,var(--h4fontsize)); font-weight: var(--fontweight,var(--h4fontweight)); font-family: var(--headingsfontfamily),var(--nv-fallback-ff); line-height: var(--lineheight,var(--h4lineheight)); letter-spacing: var(--letterspacing,var(--h4letterspacing)); text-transform: var(--texttransform,var(--h4texttransform));">15 комментариев для “VBA Excel. Выделенный диапазон ячеек (адрес, выбор, строки)”</h2></div><ol class="nv-comments-list" style="box-sizing: border-box; margin: 0px 0px 80px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment even thread-even depth-1" id="comment-item-7177" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-7177" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Владимир</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-7177" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2021-07-01T11:22:42+03:00" content="2021-07-01" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">01.07.2021 в 11:22</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Добрый день.<br style="box-sizing: border-box;">Есть такой вопрос. Пытаюсь написать макрос, который бы в выделенных несмежных диапазонах (диапазон — это либо одна вся строка, либо несколько строк), вставлял указанное кол-во строк (через InputBox) внутри диапазона. С одним диапазоном проблем нет. Но стоит выделить более одного диапазона, как макрос работает неверно. Причину я знаю. При добавлении новых строк в первый диапазон, строки смещаются вниз, но выделение остается на месте. И получается, что уже выделен совершенно не тот диапазон, который я выделял изначально. Представляю, что надо как-то применить смещение (даже пытался), но так и добился нужного результата. Не подскажите, как можно эффективно решить эту проблему.</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment odd alt depth-2" id="comment-item-7178" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-7178" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Владимир</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-7178" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2021-07-01T13:28:33+03:00" content="2021-07-01" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">01.07.2021 в 13:28</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Прошу прощения. Можно не отвечать, все-таки я добил этот вопрос. Нашел решение.</p></div></div></article></li></ol></li><li class="comment even thread-odd thread-alt depth-1" id="comment-item-9314" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-9314" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Петр</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-9314" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2022-06-14T10:43:16+03:00" content="2022-06-14" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">14.06.2022 в 10:43</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Здравствуйте, помогите, пожалуйста, написать программу:<br style="box-sizing: border-box;">В ячейки В3:С15 рабочего листа «Лист2» занести формулу «=54*10+146» и установить цвет фона красный</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment byuser comment-author-rkjey1 bypostauthor odd alt depth-2" id="comment-item-9317" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; display: block; border-bottom: 2px solid;"><article id="comment-9317" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Евгений</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-9317" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2022-06-14T14:56:14+03:00" content="2022-06-14" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">14.06.2022 в 14:56</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 4px 12px 0px;">Добрый день!</p><div id="urvanov-syntax-highlighter-65073f04c57a1861997593" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 925px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 923px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c57a1861997593-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c57a1861997593-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c57a1861997593-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c57a1861997593-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c57a1861997593-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c57a1861997593-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 905.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c57a1861997593-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c57a1861997593-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">    </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">With</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Sheets</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Лист2"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Range</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"B3:C15"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c57a1861997593-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">        </span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">FormulaLocal</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"=54*10+146"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c57a1861997593-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">        </span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Interior</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Color</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">vbRed</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c57a1861997593-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">    </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">With</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c57a1861997593-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;"></p></div></div></article></li></ol></li><li class="comment even thread-even depth-1" id="comment-item-9635" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-9635" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Дмитрий</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-9635" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2022-07-19T11:22:59+03:00" content="2022-07-19" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">19.07.2022 в 11:22</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Добрый день!<br style="box-sizing: border-box;">Подскажите, как можно определить адреса двух и более выделенных не смежных ячеек, но при этом присвоить их отдельным переменным для возможности дальнейшей работы с этими ячейками.</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment byuser comment-author-rkjey1 bypostauthor odd alt depth-2" id="comment-item-9644" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; display: block; border-bottom: 2px solid;"><article id="comment-9644" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Евгений</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-9644" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2022-07-19T21:25:16+03:00" content="2022-07-19" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">19.07.2022 в 21:25</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 4px 12px 0px;">Здравствуйте, Дмитрий!<br style="box-sizing: border-box;">Могу предложить такой вариант:</p><div id="urvanov-syntax-highlighter-65073f04c5713669244787" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 925px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 923px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">7</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-8" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">8</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-9" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">9</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5713669244787-10" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">10</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 897.734px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">st</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">String</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">ob</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Variant</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">n</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Byte</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">i</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Byte</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">st</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Split</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Selection</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Address</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">","</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">n</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">UBound</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">st</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">ReDim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">ob</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">n</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">    </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">For</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">0</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">To</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">n</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">        </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Set</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">ob</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Range</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">st</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-8" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">    </span><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Next</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-9" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-c" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(255, 128, 0) !important;">'MsgBox ob(3) 'возвратит значение четвертой выделенной ячейки</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5713669244787-10" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;"></p></div></div></article></li></ol></li><li class="comment even thread-odd thread-alt depth-1" id="comment-item-10660" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-10660" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Дмитрий</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-10660" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2022-10-11T12:42:05+03:00" content="2022-10-11" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">11.10.2022 в 12:42</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Добрый день!<br style="box-sizing: border-box;">Имеем таблицу:<br style="box-sizing: border-box;">1. столбцы таблицы — 1 строка название отдела (4-5 столбцов), 2 строка сотрудники (по 4-5 чел.). Сотрудники объединены под отделом.<br style="box-sizing: border-box;">2. строки таблицы — функции отделов. Напротив каждой функции стоит отметка какому отделу и сотруднику это принадлежит. При примитивной задаче определения какая функция к какому отделу относится — выставляем фильтр по номеру отдела и получаем результат. Неудобство в том, что отделы и сотрудники не умещаются в ширину листа, а их фактические функции после фильтрации приходится искать на другом конце документа. то есть например, есть функции А,Б,В, есть отделы 1,2,3. При выборе всех функций — отдел 1 отражается рядом, а отдел 3 далеко от функций.<br style="box-sizing: border-box;">Необходим макрос, чтобы при выборе определенного отдела показывались рядом его функции и это было в соседних ячейках.</p></div></div></article></li><li class="comment odd alt thread-even depth-1" id="comment-item-12441" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-12441" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Александр</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12441" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-18T19:30:23+03:00" content="2023-04-18" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">18.04.2023 в 19:30</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Здравствуйте, Евгений!<br style="box-sizing: border-box;">Я копирую с Лист1 на Лист2 строки, как сделать переход на новую строку в неактивном листе? (Лист2)<br style="box-sizing: border-box;">Не делая его активным. Спасибо.</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment byuser comment-author-rkjey1 bypostauthor even depth-2" id="comment-item-12442" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; display: block; border-bottom: 2px solid;"><article id="comment-12442" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Евгений</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12442" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-18T23:57:29+03:00" content="2023-04-18" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">18.04.2023 в 23:57</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 4px 12px 0px;">Здравствуйте, Александр!<br style="box-sizing: border-box;">Так, с помощью цикла, можно скопировать десять первых строк с Лист1 на Лист2:</p><div id="urvanov-syntax-highlighter-65073f04c561f301941350" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 925px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 923px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c561f301941350-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c561f301941350-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c561f301941350-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c561f301941350-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c561f301941350-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c561f301941350-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 905.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c561f301941350-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c561f301941350-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">i</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Long</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c561f301941350-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">    </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">For</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">To</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">10</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c561f301941350-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">        </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Sheets</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Лист1"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Rows</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Copy </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Sheets</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Лист2"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Rows</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">i</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c561f301941350-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">    </span><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Next</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c561f301941350-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;"></p></div></div></article></li></ol></li><li class="comment odd alt thread-odd thread-alt depth-1" id="comment-item-12511" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-12511" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Артем</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12511" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-26T16:34:49+03:00" content="2023-04-26" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">26.04.2023 в 16:34</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Здравствуйте! Как в последнюю свободную ячейку диапазона вставить формулу СУММ?</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment byuser comment-author-rkjey1 bypostauthor even depth-2" id="comment-item-12512" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; display: block; border-bottom: 2px solid;"><article id="comment-12512" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Евгений</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12512" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-26T22:07:02+03:00" content="2023-04-26" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">26.04.2023 в 22:07</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 4px 12px 0px;">Здравствуйте, Артем!<br style="box-sizing: border-box;">Для столбца E код будет такой:</p><div id="urvanov-syntax-highlighter-65073f04c5595850047166" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 925px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 923px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5595850047166-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5595850047166-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5595850047166-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c5595850047166-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c5595850047166-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 905.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5595850047166-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5595850047166-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">r</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Long</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5595850047166-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">r</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Range</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"A1"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">CurrentRegion</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Rows</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Count</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c5595850047166-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Cells</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">r</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">+</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">5</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">FormulaLocal</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"=СУММ(E2:E"</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">r</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">&amp;</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">")"</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c5595850047166-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;"></p></div></div></article></li></ol></li><li class="comment odd alt thread-even depth-1" id="comment-item-12522" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-12522" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Дмитрий</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12522" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-27T16:37:12+03:00" content="2023-04-27" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">27.04.2023 в 16:37</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Доброго времени суток!) Подскажите пожалуйста, как можно написать код через переменную для того, чтобы на каждом листе книги возле определённого столбца (допустим, "с") внизу, в свободной ячейке проставлялось слово "количество"?</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment byuser comment-author-rkjey1 bypostauthor even depth-2" id="comment-item-12524" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; display: block; border-bottom: 2px solid;"><article id="comment-12524" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Евгений</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12524" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-27T23:27:21+03:00" content="2023-04-27" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">27.04.2023 в 23:27</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Здравствуйте, Дмитрий!<br style="box-sizing: border-box;">Что должно быть в переменной? Слово "количество"?</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment odd alt depth-3" id="comment-item-12531" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; border-bottom: 2px solid;"><article id="comment-12531" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Дмитрий</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12531" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-29T12:29:46+03:00" content="2023-04-29" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">29.04.2023 в 12:29</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;">Переменной задать все рабочие листы книги, на каждом листе возле столбца "С"(в столбце "B"), в свободной ячейке проставлялось слово "количество".</p></div></div></article></li><li class="children" role="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px 0px 0px 15px;"><ol style="box-sizing: border-box; margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: var(--listpad,0); list-style: none;"><li class="comment byuser comment-author-rkjey1 bypostauthor even depth-4" id="comment-item-12534" style="box-sizing: border-box; margin: 0px 0px 40px; padding: 0px 0px 40px; display: block; border-bottom: 2px solid;"><article id="comment-12534" class="nv-comment-article" style="box-sizing: border-box; word-break: break-word; display: flex; gap: 20px;"><div class="nv-comment-avatar" style="box-sizing: border-box; flex-shrink: 0;"></div><div class="comment-content" style="box-sizing: border-box; flex: 1 1 0%;"><div class="nv-comment-header" style="box-sizing: border-box; display: flex; align-items: center; margin-bottom: 30px;"><div class="comment-author vcard" style="box-sizing: border-box; display: grid;"><span class="fn author" style="box-sizing: border-box; text-transform: none; font-weight: 700;">Евгений</span><a href="https://vremya-ne-zhdet.ru/vba-excel/vydelennyy-diapazon-yacheyek-selection-address-range/#comment-12534" style="box-sizing: border-box; --linkdeco: none; color: var(--color,var(--nv-text-color)); cursor: pointer; text-decoration: var(--linkdeco);"><time class="entry-date published" datetime="2023-04-29T20:58:44+03:00" content="2023-04-29" style="box-sizing: border-box; font-size: 0.9em; opacity: 0.7;">29.04.2023 в 20:58</time></a></div><div class="edit-reply" style="box-sizing: border-box; padding: 0px 12px 4px; font-size: 0.9em; font-weight: 700; text-transform: uppercase; margin-left: auto;"></div></div><div class="nv-comment-content comment nv-content-wrap" style="box-sizing: border-box; margin-bottom: 0px !important; --listpad: 20px; --liststyle: disc; --img-m: 24px; font-size: 14px; background-color: rgb(245, 245, 245);"><p style="box-sizing: border-box; margin: 0px 0px 30px; padding: 4px 12px 0px;"></p><div id="urvanov-syntax-highlighter-65073f04c548d179796219" class="urvanov-syntax-highlighter-syntax crayon-theme-classic urvanov-syntax-highlighter-font-verdana urvanov-syntax-highlighter-os-pc print-yes notranslate" data-settings=" no-popup minimize scroll-always" style="box-sizing: border-box; text-align: left; text-size-adjust: none; overflow: hidden !important; position: relative !important; direction: ltr !important; width: 895px; padding: 0px; margin: 12px 0px; font-family: Monaco, MonacoRegular, &quot;Courier New&quot;, monospace; font-weight: 500; border-width: 1px !important; border-color: rgb(153, 153, 153) !important; border-style: solid !important; text-shadow: none !important; background: rgb(253, 253, 253) !important; font-size: 12px !important; line-height: 15px !important; height: auto;"><div class="urvanov-syntax-highlighter-plain-wrap" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px !important; margin: 0px !important; text-align: left; height: auto !important;"></div><div class="urvanov-syntax-highlighter-main" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; width: 893px; overflow: auto; position: relative; z-index: 1;"><table class="crayon-table" style="box-sizing: border-box; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; margin-top: 0px !important; margin-right: 0px !important; margin-bottom: 0px !important; margin-left: 0px; width: auto !important; word-break: initial; font-family: Verdana, Arial, sans !important; padding: 0px !important; background: none !important; table-layout: auto !important;"><tbody style="box-sizing: border-box; font-family: Verdana, Arial, sans !important;"><tr class="urvanov-syntax-highlighter-row" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; padding: 0px !important; border: none !important; background: none !important; vertical-align: top !important; margin: 0px !important;"><td class="crayon-nums " data-settings="show" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: rgb(223, 239, 255) !important; font-family: Verdana, Arial, sans !important; user-select: none; vertical-align: top !important; margin: 0px !important; color: rgb(84, 153, 222) !important;"><div class="urvanov-syntax-highlighter-nums-content" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: 0px center; border: 0px; padding: 0px; margin: 0px; text-align: left; white-space: nowrap; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">1</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-2" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">2</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">3</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-4" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">4</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">5</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-6" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">6</div><div class="crayon-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;">7</div><div class="crayon-num crayon-striped-num" data-line="urvanov-syntax-highlighter-65073f04c548d179796219-8" style="box-sizing: border-box; font-family: inherit; background: rgb(200, 225, 250) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: center; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(49, 124, 197) !important;">8</div></div></td><td class="urvanov-syntax-highlighter-code" style="box-sizing: border-box; padding: 0px !important; text-align: left; font-size: 0.9em; border: none !important; background: none !important; font-family: Verdana, Arial, sans !important; width: 875.359px; vertical-align: top !important; margin: 0px !important;"><div class="crayon-pre" style="box-sizing: border-box; font-family: Verdana, Arial, sans !important; background: none !important; border: none !important; padding: 0px; margin: 0px; text-align: left; color: rgb(0, 0, 0); white-space: pre; overflow: visible; tab-size: 4; font-size: 12px !important; line-height: 15px !important;"><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-1" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Primer</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-2" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Dim</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">mySheet </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">As</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Worksheet</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-3" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">    </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">For</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Each</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">mySheet </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">In</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">ThisWorkbook</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Worksheets</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-4" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">        </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">With</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-i" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 0, 0) !important;">mySheet</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-5" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">            </span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Cells</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-e" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 78, 208) !important;">Range</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"B1"</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">(</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">xlDown</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">.</span><span class="crayon-v" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 45, 122) !important;">Row</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">+</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">1</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">,</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-cn" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(206, 0, 0) !important;">2</span><span class="crayon-sy" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(51, 51, 51) !important;">)</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-o" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">=</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-s" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 128, 0) !important;">"Количество"</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-6" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">        </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">With</span></div><div class="crayon-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-7" style="box-sizing: border-box; font-family: inherit; background: 0px center; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;">    </span><span class="crayon-r" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Next</span></div><div class="crayon-line crayon-striped-line" id="urvanov-syntax-highlighter-65073f04c548d179796219-8" style="box-sizing: border-box; font-family: inherit; background: rgb(247, 247, 247) !important; border: 0px; padding: 0px 5px; margin: 0px; text-align: left; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important;"><span class="crayon-st" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">End</span><span class="crayon-h" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(0, 111, 224) !important;"> </span><span class="crayon-t" style="box-sizing: border-box; font-family: inherit; height: inherit; font-size: inherit !important; line-height: inherit !important; font-weight: inherit !important; color: rgb(128, 0, 128) !important;">Sub</span></div></div></td></tr></tbody></table></div></div><p style="box-sizing: border-box; margin: 0px; padding: 4px 12px 0px;"></p></div></div></article></li></ol></li></ol></li></ol></li></ol></div><p class="no-comments" style="box-sizing: border-box; margin: 0px 0px 30px; padding: 0px;">Обсуждение закрыто.</p></div><!--EndFragment-->
</body>
</html></body></html>